Customers EDA

Dataset statistics

Number of variables	12
Number of observations	2773
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	281.6 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`avg_basket_size` is highly overall correlated with `gross_revenue` and 1 other fields	High correlation
`avg_days_orders` is highly overall correlated with `frequency`	High correlation
`avg_products_order` is highly overall correlated with `avg_ticket` and 1 other fields	High correlation
`avg_ticket` is highly overall correlated with `avg_products_order`	High correlation
`frequency` is highly overall correlated with `avg_days_orders`	High correlation
`gross_revenue` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`orders` is highly overall correlated with `gross_revenue` and 2 other fields	High correlation
`total_items` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`total_products` is highly overall correlated with `avg_products_order` and 3 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 27.67827332)	Skewed
`frequency` is highly skewed (γ1 = 47.40535083)	Skewed
`items_returned` is highly skewed (γ1 = 21.6260127)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 33 (1.2%) zeros	Zeros
`items_returned` has 1481 (53.4%) zeros	Zeros

Reproduction

Analysis started	2024-05-22 11:56:44.120033
Analysis finished	2024-05-22 11:56:58.766734
Duration	14.65 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

customer_id
Real number (ℝ)

UNIQUE

Distinct	2773
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15285.281

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12626.6
Q1	13815
median	15241
Q3	16780
95-th percentile	17950.4
Maximum	18287
Range	5940
Interquartile range (IQR)	2965

Descriptive statistics

Standard deviation	1715.1526
Coefficient of variation (CV)	0.11220942
Kurtosis	-1.2070293
Mean	15285.281
Median Absolute Deviation (MAD)	1484
Skewness	0.016612507
Sum	42386085
Variance	2941748.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15060	1	< 0.1%
17850	1	< 0.1%
13047	1	< 0.1%
12583	1	< 0.1%
13748	1	< 0.1%
15100	1	< 0.1%
15291	1	< 0.1%
14688	1	< 0.1%
17809	1	< 0.1%
15311	1	< 0.1%
Other values (2763)	2763	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	2759
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2844.942

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.548
Q1	628
median	1169.94
Q3	2423.32
95-th percentile	7490.982
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1795.32

Descriptive statistics

Standard deviation	10466.686
Coefficient of variation (CV)	3.6790506
Kurtosis	372.80205
Mean	2844.942
Median Absolute Deviation (MAD)	689.02
Skewness	17.097705
Sum	7889024.2
Variance	1.0955151 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1078.96	2	0.1%
1025.44	2	0.1%
889.93	2	0.1%
734.94	2	0.1%
331	2	0.1%
1314.45	2	0.1%
379.65	2	0.1%
1353.74	2	0.1%
598.2	2	0.1%
2053.02	2	0.1%
Other values (2749)	2753	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140438.72	1	< 0.1%
124564.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65019.62	1	< 0.1%

recency_days
Real number (ℝ)

ZEROS

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.648395

Minimum	0
Maximum	372
Zeros	33
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.422907
Coefficient of variation (CV)	1.2078525
Kurtosis	3.4305436
Mean	56.648395
Median Absolute Deviation (MAD)	23
Skewness	1.8980349
Sum	157086
Variance	4681.6942
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	87	3.1%
3	85	3.1%
2	85	3.1%
8	76	2.7%
10	67	2.4%
9	66	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2026	73.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	1.2%
1	99	3.6%
2	85	3.1%
3	85	3.1%
4	87	3.1%
5	43	1.6%
7	65	2.3%
8	76	2.7%
9	66	2.4%
10	67	2.4%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%
333	2	0.1%
330	1	< 0.1%

orders
Real number (ℝ)

HIGH CORRELATION

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0544537

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.0729125
Coefficient of variation (CV)	1.4985518
Kurtosis	183.89793
Mean	6.0544537
Median Absolute Deviation (MAD)	2
Skewness	10.623447
Sum	16789
Variance	82.317741
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	780	28.1%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	780	28.1%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

total_items
Real number (ℝ)

HIGH CORRELATION

Distinct	1631
Distinct (%)	58.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1669.2236

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	119
Q1	330
median	699
Q3	1478
95-th percentile	4614
Maximum	196844
Range	196842
Interquartile range (IQR)	1148

Descriptive statistics

Standard deviation	5885.8021
Coefficient of variation (CV)	3.5260717
Kurtosis	486.75708
Mean	1669.2236
Median Absolute Deviation (MAD)	449
Skewness	18.198824
Sum	4628757
Variance	34642666
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
246	8	0.3%
150	8	0.3%
394	7	0.3%
260	7	0.3%
1200	7	0.3%
200	7	0.3%
300	7	0.3%
272	7	0.3%
219	7	0.3%
Other values (1621)	2697	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%
33	2	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
79963	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%
50255	1	< 0.1%

total_products
Real number (ℝ)

HIGH CORRELATION

Distinct	468
Distinct (%)	16.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	129.76884

Minimum	2
Maximum	7837
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	10
Q1	34
median	72
Q3	143
95-th percentile	400.2
Maximum	7837
Range	7835
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	277.76899
Coefficient of variation (CV)	2.1404907
Kurtosis	336.71947
Mean	129.76884
Median Absolute Deviation (MAD)	45
Skewness	15.345709
Sum	359849
Variance	77155.614
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	40	1.4%
35	34	1.2%
26	30	1.1%
27	30	1.1%
29	28	1.0%
33	27	1.0%
31	27	1.0%
15	27	1.0%
20	26	0.9%
42	26	0.9%
Other values (458)	2478	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	11	0.4%
3	12	0.4%
4	16	0.6%
5	16	0.6%
6	24	0.9%
7	14	0.5%
8	13	0.5%
9	20	0.7%
10	18	0.6%
11	23	0.8%

Value	Count	Frequency (%)
7837	1	< 0.1%
5670	1	< 0.1%
5095	1	< 0.1%
4577	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1636	1	< 0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1918
Distinct (%)	69.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.106498

Minimum	2.15
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2.15
5-th percentile	4.85
Q1	12.42
median	17.94
Q3	25.03
95-th percentile	87.76
Maximum	4453.43
Range	4451.28
Interquartile range (IQR)	12.61

Descriptive statistics

Standard deviation	107.63141
Coefficient of variation (CV)	3.3523249
Kurtosis	1054.6276
Mean	32.106498
Median Absolute Deviation (MAD)	6.34
Skewness	27.678273
Sum	89031.32
Variance	11584.521
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.49	7	0.3%
16.82	6	0.2%
17.66	6	0.2%
19.06	6	0.2%
17.71	5	0.2%
17.13	5	0.2%
19.44	5	0.2%
17.81	5	0.2%
20.75	5	0.2%
16.92	5	0.2%
Other values (1908)	2718	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.15	1	< 0.1%
2.43	1	< 0.1%
2.46	1	< 0.1%
2.51	1	< 0.1%
2.52	1	< 0.1%
2.65	1	< 0.1%
2.66	1	< 0.1%
2.71	1	< 0.1%
2.76	1	< 0.1%
2.77	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.99	1	< 0.1%
872.13	1	< 0.1%
841.02	1	< 0.1%
651.17	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%
602.45	1	< 0.1%

avg_days_orders
Real number (ℝ)

HIGH CORRELATION

Distinct	1155
Distinct (%)	41.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.756379

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34.222222
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	64.777778

Descriptive statistics

Standard deviation	66.483798
Coefficient of variation (CV)	0.84417032
Kurtosis	3.6897278
Mean	78.756379
Median Absolute Deviation (MAD)	30
Skewness	1.8311845
Sum	218391.44
Variance	4420.0954
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	21	0.8%
46	18	0.6%
55	17	0.6%
91	16	0.6%
31	16	0.6%
49	16	0.6%
42	15	0.5%
35	15	0.5%
21	15	0.5%
14	14	0.5%
Other values (1145)	2610	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.3%
2	4	0.1%
2.861538462	1	< 0.1%
3	6	0.2%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	5	0.2%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1228
Distinct (%)	44.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.061834891

Minimum	0.0054644809
Maximum	34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0.0054644809
5-th percentile	0.0087719298
Q1	0.015873016
median	0.024523161
Q3	0.042145594
95-th percentile	0.11800465
Maximum	34
Range	33.994536
Interquartile range (IQR)	0.026272578

Descriptive statistics

Standard deviation	0.66955925
Coefficient of variation (CV)	10.828179
Kurtosis	2386.2478
Mean	0.061834891
Median Absolute Deviation (MAD)	0.010786897
Skewness	47.405351
Sum	171.46815
Variance	0.44830959
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.07142857143	16	0.6%
0.04761904762	15	0.5%
0.01587301587	14	0.5%
0.0303030303	14	0.5%
0.02857142857	14	0.5%
0.06451612903	13	0.5%
0.02380952381	13	0.5%
0.1428571429	13	0.5%
0.1176470588	12	0.4%
0.025	12	0.4%
Other values (1218)	2637	95.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005602240896	2	0.1%
0.005617977528	1	< 0.1%
0.005633802817	2	0.1%
0.005681818182	1	< 0.1%
0.005698005698	2	0.1%
0.005714285714	3	0.1%

Value	Count	Frequency (%)
34	1	< 0.1%
6	1	< 0.1%
4	1	< 0.1%
2	6	0.2%
1.5	1	< 0.1%
1.333333333	2	0.1%
1	4	0.1%
0.6666666667	3	0.1%
0.5522788204	1	< 0.1%
0.5349462366	1	< 0.1%

items_returned
Real number (ℝ)

SKEWED ZEROS

Distinct	204
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.973675

Minimum	0
Maximum	9014
Zeros	1481
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	96.8
Maximum	9014
Range	9014
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	290.71429
Coefficient of variation (CV)	8.3123747
Kurtosis	571.74568
Mean	34.973675
Median Absolute Deviation (MAD)	0
Skewness	21.626013
Sum	96982
Variance	84514.798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
6	63	2.3%
5	55	2.0%
12	45	1.6%
8	39	1.4%
7	38	1.4%
Other values (194)	652	23.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
5	55	2.0%
6	63	2.3%
7	38	1.4%
8	39	1.4%
9	38	1.4%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

avg_basket_size
Real number (ℝ)

HIGH CORRELATION

Distinct	1931
Distinct (%)	69.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	230.94908

Minimum	1
Maximum	6009.3333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	45
Q1	103.33333
median	172
Q3	278.09524
95-th percentile	583.6
Maximum	6009.3333
Range	6008.3333
Interquartile range (IQR)	174.7619

Descriptive statistics

Standard deviation	261.5335
Coefficient of variation (CV)	1.1324293
Kurtosis	115.89887
Mean	230.94908
Median Absolute Deviation (MAD)	81
Skewness	7.7349287
Sum	640421.79
Variance	68399.773
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
86	9	0.3%
60	8	0.3%
75	8	0.3%
105	7	0.3%
82	7	0.3%
208	7	0.3%
136	7	0.3%
73	7	0.3%
197	7	0.3%
Other values (1921)	2695	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%
11.875	1	< 0.1%

Value	Count	Frequency (%)
6009.333333	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%
1903.5	1	< 0.1%
1866.933333	1	< 0.1%

avg_products_order
Real number (ℝ)

HIGH CORRELATION

Distinct	1003
Distinct (%)	36.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.129792

Minimum	1
Maximum	299.70588
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3.5
Q1	10.133333
median	17.307692
Q3	28.111111
95-th percentile	56.648485
Maximum	299.70588
Range	298.70588
Interquartile range (IQR)	17.977778

Descriptive statistics

Standard deviation	18.867714
Coefficient of variation (CV)	0.85259337
Kurtosis	24.175983
Mean	22.129792
Median Absolute Deviation (MAD)	8.3076923
Skewness	3.1580319
Sum	61365.914
Variance	355.99064
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	44	1.6%
14	31	1.1%
11	29	1.0%
9	26	0.9%
1	26	0.9%
10.5	25	0.9%
7.5	25	0.9%
17.5	25	0.9%
18	24	0.9%
9.5	24	0.9%
Other values (993)	2494	89.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	26	0.9%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	7	0.3%
1.568181818	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
2	21	0.8%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
203.5	1	< 0.1%
145	1	< 0.1%
136.125	1	< 0.1%
135.5	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%
114	1	< 0.1%
110.3333333	1	< 0.1%
109.6666667	2	0.1%

Auto

Heatmap
Table

	avg_basket_size	avg_days_orders	avg_products_order	avg_ticket	customer_id	frequency	gross_revenue	items_returned	orders	recency_days	total_items	total_products
avg_basket_size	1.000	-0.043	0.433	0.198	-0.121	0.025	0.602	0.214	0.126	-0.103	0.759	0.403
avg_days_orders	-0.043	1.000	0.062	-0.080	-0.012	-0.951	-0.367	-0.215	-0.476	0.225	-0.344	-0.300
avg_products_order	0.433	0.062	1.000	-0.626	0.006	-0.071	0.282	0.027	0.016	-0.105	0.312	0.721
avg_ticket	0.198	-0.080	-0.626	1.000	-0.141	0.081	0.273	0.188	0.091	0.035	0.195	-0.381
customer_id	-0.121	-0.012	0.006	-0.141	1.000	0.013	-0.086	-0.058	0.013	0.014	-0.079	0.013
frequency	0.025	-0.951	-0.071	0.081	0.013	1.000	0.255	0.174	0.317	-0.125	0.237	0.198
gross_revenue	0.602	-0.367	0.282	0.273	-0.086	0.255	1.000	0.461	0.763	-0.373	0.922	0.723
items_returned	0.214	-0.215	0.027	0.188	-0.058	0.174	0.461	1.000	0.427	-0.186	0.426	0.329
orders	0.126	-0.476	0.016	0.091	0.013	0.317	0.763	0.427	1.000	-0.448	0.704	0.659
recency_days	-0.103	0.225	-0.105	0.035	0.014	-0.125	-0.373	-0.186	-0.448	1.000	-0.365	-0.392
total_items	0.759	-0.344	0.312	0.195	-0.079	0.237	0.922	0.426	0.704	-0.365	1.000	0.709
total_products	0.403	-0.300	0.721	-0.381	0.013	0.198	0.723	0.329	0.659	-0.392	0.709	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	gross_revenue	recency_days	orders	total_items	total_products	avg_ticket	avg_days_orders	frequency	items_returned	avg_basket_size	avg_products_order
0	17850	5391.21	372.0	34.0	1733.0	297.0	18.15	1.000000	34.000000	40.0	50.970588	8.735294
1	13047	3232.59	56.0	9.0	1390.0	171.0	18.90	52.833333	0.028391	35.0	154.444444	19.000000
2	12583	6705.38	2.0	15.0	5028.0	232.0	28.90	26.500000	0.040431	50.0	335.200000	15.466667
3	13748	948.25	95.0	5.0	439.0	28.0	33.87	92.666667	0.017986	0.0	87.800000	5.600000
4	15100	876.00	333.0	3.0	80.0	3.0	292.00	20.000000	0.075000	22.0	26.666667	1.000000
5	15291	4623.30	25.0	14.0	2102.0	102.0	45.33	26.769231	0.040230	29.0	150.142857	7.285714
6	14688	5630.87	7.0	21.0	3621.0	327.0	17.22	19.263158	0.057377	399.0	172.428571	15.571429
7	17809	5411.91	16.0	12.0	2057.0	61.0	88.72	39.666667	0.033613	41.0	171.416667	5.083333
8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.54	4.191011	0.243968	474.0	419.714286	26.142857
9	16098	2005.63	87.0	7.0	613.0	67.0	29.93	47.666667	0.024476	0.0	87.571429	9.571429

	customer_id	gross_revenue	recency_days	orders	total_items	total_products	avg_ticket	avg_days_orders	frequency	items_returned	avg_basket_size	avg_products_order
5610	17290	525.24	3.0	2.0	404.0	102.0	5.15	13.0	0.153846	0.0	202.000000	51.0
5619	14785	77.40	10.0	2.0	84.0	3.0	25.80	5.0	0.400000	0.0	42.000000	1.5
5620	17254	272.44	4.0	2.0	252.0	112.0	2.43	11.0	0.181818	0.0	126.000000	56.0
5636	17232	421.52	2.0	2.0	203.0	36.0	11.71	12.0	0.166667	0.0	101.500000	18.0
5637	17468	137.00	10.0	2.0	116.0	5.0	27.40	4.0	0.500000	0.0	58.000000	2.5
5648	13596	697.04	5.0	2.0	406.0	166.0	4.20	7.0	0.285714	0.0	203.000000	83.0
5654	14893	1237.85	9.0	2.0	799.0	73.0	16.96	2.0	1.000000	0.0	399.500000	36.5
5679	14126	706.13	7.0	3.0	508.0	15.0	47.08	3.0	1.000000	50.0	169.333333	5.0
5685	13521	1092.39	1.0	3.0	733.0	435.0	2.51	4.5	0.333333	0.0	244.333333	145.0
5695	15060	301.84	8.0	4.0	262.0	120.0	2.52	1.0	4.000000	0.0	65.500000	30.0

Overview

Variables

Interactions

Correlations

Missing values

Sample